Problem Note 68412: SAS/ACCESS® Interface to Greenplum might not detect a query being killed in Greenplum, resulting in the wrong number of rows being returned
 |  |  |  |  |
If a query that is submitted to a Greenplum database is terminated by the Greenplum administrator, the original SAS® query might return fewer rows than expected. There is no indication of an error or warning, and so the query appears to have completed successfully.
Sometimes an error is observed in the SAS log. Here is an example:
The Greenplum system logs show the termination, as in this example:
A workaround is to set READBUFF=1 either as a data set option or in the connection options of the LIBNAME or CONNECT statement. This setting does not prevent the wrong number of rows being read, but it does provide an error message in the SAS log that is similar to one of the following:
ERROR: PROC SQL runtime error for operation=sqxsrc.
ERROR: An error has occurred.
ERROR: PROC SQL runtime error for operation=sqxsrc.
ERROR: An error has occurred.
ERROR: CLI close cursor error: [SAS][ODBC Greenplum Wire Protocol driver]Socket closed. : [SAS][ODBC Greenplum Wire Protocol driver]Socket closed.
Note: Adding READBUFF=1 might cause a performance overhead.
Click the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix ensures that an error message is always written to the SAS log when a Greenplum server process is terminated.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Greenplum | Microsoft® Windows® for x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 |
| Microsoft Windows 8 Enterprise 32-bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 R2 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2008 for x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2019 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Linux for x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.43 | 9.45 | 9.4 TS1M6 | 9.4 TS1M8 | ||